﻿CREATE TABLE [sacm].[SolicitudCita] (
    [IdSolicitudCita]        INT            IDENTITY (1, 1) NOT NULL,
    [IdPaciente]             INT            NULL,
    [NomPaciente]            NVARCHAR (500) NOT NULL,
    [Email]                  VARCHAR (250)  NOT NULL,
    [IdDoctor]               INT            NOT NULL,
    [FechaSolicitudCita]     DATE           NOT NULL,
    [HoraSolicitudCita]      TIME (7)       NOT NULL,
    [IdEstatusSolicitudCita] INT            NULL,
    [FechaMod]               DATETIME       NULL,
    [IpMod]                  VARCHAR (15)   NULL,
    [IdUsuarioMod]           INT            NULL,
    [IdEmpresa]              INT            NOT NULL,
    [IdSucursal]             INT            NOT NULL
);



